Part 1

Setting Up a Workbook

Creating Workbooks .

Modifying Workbooks

Modifying Worksheets .

Customizing the Excel 2010 Program Window

Zooming In on a Worksheet

Arranging Multiple Workbook Windows

Adding Buttons to the Quick Access Toolbar

Customizing the Ribbon

Maximizing Usable Space in the Program Window

Working with Data and Excel Tables

Entering and Revising Data

Moving Data Within a Workbook

Finding and Replacing Data

Correcting and Expanding Upon Worksheet Data

Defining Excel Tables

Printing

Adding Headers and Footers to Printed Pages

Preparing Worksheets for Printing

Previewing Worksheets Before Printing

Changing Page Breaks in a Worksheet

Changing the Page Printing Order for Worksheets

Printing Worksheets

Printing Parts of Worksheets .

Printing Charts .

Part 2

Performing Calculations on Data

Naming Groups of Data

Creating Formulas to Calculate Values

Summarizing Data That Meets Specific Conditions

Finding and Correcting Errors in Calculations

Changing Workbook Appearance

Formatting Cells

Defining Styles

Applying Workbook Themes and Excel Table Styles

Making Numbers Easier to Read

Changing the Appearance of Data Based on Its Value

Adding Images to Worksheets

Focusing on Specific Data by Using Filters

Limiting Data That Appears on Your Screen

Manipulating Worksheet Data

Selecting List Rows at Random

Summarizing Worksheets with Hidden and Filtered Rows

Finding Unique Values Within a Data Set

Defining Valid Sets of Values for Ranges of Cells

Reordering and Summarizing Data

Sorting Worksheet Data

Organizing Data into Levels

Looking Up Information in a Worksheet

Combining Data from Multiple Sources

Using Workbooks as Templates for Other Workbooks

Linking to Data in Other Worksheets and Workbooks

Consolidating Multiple Sets of Data into a Single Workbook

Grouping Multiple Sets of Data

Part 3

Analyzing Alternative Data Sets

Defining an Alternative Data Set

Defining Multiple Alternative Data Sets

Varying Your Data to Get a Desired Result by Using Goal Seek

Finding Optimal Solutions by Using Solver

Analyzing Data by Using Descriptive Statistics

Creating Dynamic Worksheets by Using PivotTables

Analyzing Data Dynamically by Using PivotTables

Filtering, Showing, and Hiding PivotTable Data

Editing PivotTables

Formatting PivotTables

Creating PivotTables from External Data

Creating Charts and Graphics

Creating Charts

Customizing the Appearance of Charts

Finding Trends in Your Data

Summarizing Your Data by Using Sparklines

Creating Dynamic Charts by Using PivotCharts

Creating Diagrams by Using SmartArt

Creating Shapes and Mathematical Equations

Automating Repetitive Tasks by Using Macros

Enabling and Examining Macros

Macro Security in Excel 2010

Examining Macros

Creating and Modifying Macros

Running Macros When a Button Is Clicked

Running Macros When a Workbook Is Opened

Working with Other Microsoft Office Programs

Including Office Documents in Workbooks

Storing Workbooks as Parts of Other Office Documents

Creating Hyperlinks

Pasting Charts into Other Documents

Collaborating with Colleagues

Sharing Workbooks

Sidebar: Saving a Workbook for Secure Electronic Distribution

Managing Comments

Tracking and Managing Colleagues’ Changes

Protecting Workbooks and Worksheets

Sidebar: Finalizing a Workbook

Authenticating Workbooks

Saving Workbooks for the Web